Statistics

Nestor does not handle statistics yet. You can use advanced searches and data exports to handle most common requests with Excel pivot tables.

Delays computation

Concerning delay computation between two dates, use the following functions in excel.

Submission date	Final decision date	Function
25/05/2023	27/06/2023	24
25/05/2023
02/01/2023	01/02/2023	23
02/01/2023	15/02/2023	33
03/01/2023
18/04/2023	17/05/2023	22

 

Function for computing every day

=IF(OR(A1="",B1=""),"",DAYS(A1,B1))

French version

=SI(OU(A1="";B1="");"";JOURS(A1;B1))

 

Function for computing only working days

=IF(OR(A1="",B1=""),"",NETWORKDAYS(A1,B1))

French version:

=SI(OU(A1="";B1="");"";NB.JOURS.OUVRES(A1;B1))