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.
|
A |
B |
C |
|
| 1 | Submission date |
Final decision date |
Function |
| 2 | 25/05/2023 | 27/06/2023 | 24 |
| 3 | 25/05/2023 | ||
| 4 | 02/01/2023 | 01/02/2023 | 23 |
| 5 | 02/01/2023 | 15/02/2023 | 33 |
| 6 | 03/01/2023 | ||
| 7 | 18/04/2023 | 17/05/2023 | 22 |
Function for computing every day
=IF(OR(A1=A2="",B1=B2=""),"",DAYS(A1,B1)A2,B2))French version
=SI(OU(A1=A2="";B1=B2="");"";JOURS(A1;B1)A2;B2))Function for computing only working days
=IF(OR(A1=A2="",B1=B2=""),"",NETWORKDAYS(A1,B1)A2,B2))French version:
=SI(OU(A1=A2="";B1=B2="");"";NB.JOURS.OUVRES(A1;B1)A2;B2))