include that weekends are free

• Re: include that weekends are free

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

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.

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

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

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

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

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

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

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

• Re: include that weekends are free

ok thnx
stay cool
saban

Participate now!

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