# Statistics

#### Day-to-day statistics

To prepare statistics on articles, you can use [advanced searches](https://doc.nestor-edp.org/books/editor-guide/page/advanced-and-saved-searches "Advanced and saved searches") and [data exports](https://doc.nestor-edp.org/books/editor-guide/page/articles-lists-views-and-exports#bkmrk-exporting-lists "Articles lists: views and exports") to get the source data. From then on, you can handle common statistics requests using [pivot tables](https://en.wikipedia.org/wiki/Pivot_table) in your favorite spreadsheet program.

---

#### Delay computations

Concerning delay computation between two dates, use the following formulas in Excel (to use column headers, [format your data as a table](https://support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664)).

<table border="1" id="bkmrk-%C2%A0-a-b-c-1-submission" style="border-collapse: collapse; width: 97.4074%; height: 79px;"><colgroup><col style="width: 4.80481%;"></col><col style="width: 20.5706%;"></col><col style="width: 21.6216%;"></col><col style="width: 53.003%;"></col></colgroup><tbody><tr style="height: 29.8px;"><td class="align-center" style="width: 53.5pt; height: 29.8px;">**1**</td><td class="align-center" style="width: 53.5pt; height: 29.8px;">Submission date  
</td><td class="align-center" style="width: 113pt; height: 29.8px;">Final decision date  
</td><td class="align-center" style="width: 60pt; height: 29.8px;">From submission to final decision (formula)</td></tr><tr style="height: 29.8px;"><td class="align-center" height="20" style="height: 29.8px; width: 53.5pt;" width="142">**2**</td><td class="align-center" height="20" style="height: 29.8px; width: 53.5pt;" width="142">25/05/2023</td><td class="align-center" style="width: 113pt; height: 29.8px;" width="151">27/06/2023</td><td align="right" class="xl64 align-center" style="width: 60pt; height: 29.8px;" width="80">24</td></tr><tr style="height: 29.8px;"><td class="align-center" height="20" style="height: 29.8px;">**3**</td><td class="align-center" height="20" style="height: 29.8px;">25/05/2023</td><td class="align-center" style="height: 29.8px;">  
</td><td class="xl64 align-center" style="height: 29.8px;">  
</td></tr></tbody></table>


---

##### Standard formula

```
=IF(OR(A2="",B2=""),"",DAYS(A2,B2))
```

French Excel version

```
=SI(OU(A2="";B2="");"";JOURS(A2;B2))
```

---

##### Recommended: column headers, needs data to be [formatted as a table](https://support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664)

See example below:

- Any missing date will output a null result (= no delay computed)
- A negative result highlights a workflow issue, and is thus output as N/A

Formula

```
=IF(
    OR([@[Publication date]]="", [@[Submission date]]=""),
    "",
    IF(
        [@[Publication date]] - [@[Submission date]] >= 0,
        [@[Publication date]] - [@[Submission date]],
        "N/A"
    )
)
```

French Excel version

```
=SI(
    OU([@[Publication date]]=""; [@[Submission date]]="");
    "";
    SI(
        [@[Publication date]] - [@[Submission date]] >= 0;
        [@[Publication date]] - [@[Submission date]];
        "N/A"
    )
)
```

<table border="0" cellpadding="0" cellspacing="0" id="bkmrk-production-date-publ" style="border-collapse: collapse; width: 810px; height: 169.5px;" width="981"><colgroup><col style="width: 279px;" width="144"></col><col style="width: 254px;" width="130"></col><col style="width: 276px;" width="143"></col></colgroup><tbody><tr style="height: 46.6px;"><td class="xl65" height="20" style="height: 46.6px; width: 108pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri; border-width: medium 0.5pt 1.5pt; border-style: none solid solid; border-color: currentcolor white white; background: rgb(21, 96, 130);" width="144">Submission date</td><td class="xl65 align-left" style="width: 98pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri; border-width: medium medium 1.5pt 0.5pt; border-style: none none solid solid; border-color: currentcolor currentcolor white white; background: rgb(21, 96, 130); height: 46.6px;" width="130">Publication date</td><td class="xl67" style="width: 107pt; height: 46.6px;" width="143">Submission to publication, with the above formula

</td></tr><tr style="height: 31.1px;"><td height="20" style="height: 31.1px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid white; background: rgb(131, 204, 235);">04/11/2025</td><td align="right" class="xl66 align-left" style="font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: white currentcolor white white; background: rgb(131, 204, 235); height: 31.1px;">02/01/2026</td><td align="right" class="xl68" style="height: 31.1px;">59</td></tr><tr style="height: 30.6px;"><td height="20" style="height: 30.6px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid white; background: rgb(192, 230, 245);">07/11/2025</td><td align="right" class="xl66 align-left" style="font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: white currentcolor white white; background: rgb(192, 230, 245); height: 30.6px;">03/01/2026</td><td align="right" class="xl68" style="height: 30.6px;">57</td></tr><tr style="height: 30.6px;"><td height="20" style="height: 30.6px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid white; background: rgb(131, 204, 235);">15/11/2025</td><td class="xl66 align-left" style="font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: white currentcolor white white; background: rgb(131, 204, 235); height: 30.6px;">  
</td><td class="xl68" style="height: 30.6px;">  
</td></tr><tr style="height: 30.6px;"><td height="20" style="height: 30.6px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt 0.5pt medium; border-style: solid solid none; border-color: white white currentcolor; background: rgb(192, 230, 245);">17/11/2025</td><td class="xl66 align-left" style="font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium 0.5pt; border-style: solid none none solid; border-color: white currentcolor currentcolor white; background: rgb(192, 230, 245); height: 30.6px;">15/11/2025</td><td class="xl68" style="height: 30.6px;"> N/A</td></tr></tbody></table>