Child pages
  • Journal Statistics

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

First, you will need to create a new, empty "Time to Complete Review" field. You will want to use the dates in the Date Confirmed and Date Completed fields for your formula- depending on your CSV files, the columns will vary. Select the Date Confirmed cell, and then the Date Completed cell while inputting the formula.  Your formula should resemble the one below:

=DATEDIF(ColumnHeaderRow#,ColumnHeaderRow#, "md"); for example, for column headers Date Confirmed=K, Date Completed=L and the first row, the formula would be =DATEDIF(K2,L2, "md")

Apply this formula to the rest of the "Time to Complete Review" row- note that reviews that are not completed will show an error message, as there will be incomplete fields. Get these out of the way and then average the field with numbers, or delete incomplete rows from spreadsheet.=AVERAGE(M2:M391)by wither sorting the "Time to Complete Review" row and only selecting non-error cells for the average, or remove incomplete reviews from the spreadsheet and average all results. this should spit out a single number of days, the average length of days for a reviewer to complete a review for your journal.


Anchor
Articles Report
Articles Report

...