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 functionsformulas in Excel.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 |
FunctionStandard for computing every dayformula
=IF(OR(A2="",B2=""),"",DAYS(A2,B2))French version
=SI(OU(A2="";B2="");"";JOURS(A2;B2))
FunctionExample forformula computingwhen onlydata workingis days
formatted as table ❤️
=IF(OR(A2=Table1[@[First referee invitation date]]="",B2=;Table1[@[Submission date]]=""),;"",NETWORKDAYS(A2,B2);DAYS(Table1[@[First referee invitation date]];Table[@[Submission date]]))In French version:
=SI(OU(A2=Tableau1[@[First referee invitation date]]="";B2=Tableau1[@[Submission date]]="");"";NB.JOURS.OUVRES(A2;B2)JOURS(Tableau1[@[First referee invitation date]];Tableau1[@[Submission date]]))