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)~~table).

	A	B	C
1	Submission date	Final decision date	~~Function~~ From submission to final decision (formula)
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))

ExampleRecommended: formulareference whenheaders, needs data isto be formatted as a 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]]))