Statistics

Day-to-day statistics

~~Nestor~~To ~~does not handle~~prepare statistics ~~yet.~~on ~~You~~articles, you can use advanced searches and data exports to get the source data. From then on, you can handle ~~most~~ common statistics requests ~~with~~using ~~Excel~~ pivot ~~tables.~~tables in your favorite spreadsheet program.

Delays computation

Delay computations

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