Statistics

Day-to-day statistics

To prepare statistics on articles, you can use advanced searches and data exports to get the source data. From then on, you can handle common statistics requests using pivot tables in your favorite spreadsheet program.

 

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