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 formulas in Excel (easier if the data is formatted as a table).
|
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 |
Standard formula
=IF(OR(A2="",B2=""),"",DAYS(A2,B2))French version
=SI(OU(A2="";B2="");"";JOURS(A2;B2))Example formula when data is formatted as table ❤️
=IF(OR(Table1[@[First referee invitation date]]="";Table1[@[Submission date]]="");"";DAYS(Table1[@[First referee invitation date]];Table[@[Submission date]]))In French
=SI(OU(Tableau1[@[First referee invitation date]]="";Tableau1[@[Submission date]]="");"";JOURS(Tableau1[@[First referee invitation date]];Tableau1[@[Submission date]]))