These reports should run in JPS each time an issue is published.

Advanced Tasks -> Reports -> Publication Turntimes

Select journal -> Specific Date Range, Start and End Date of one month (e.g., May 1 to May 31)

Publication Date

Include columns: Select all (deselect Ed Accept to Preflight Accept, Ed Accept to Image Edit Complete, and Preflight Accept to Online)

Calculate in: Calendar days

Show duration in: Days

Save as Excel

Rename file

Copy and paste Average and Median into the cumulative_turntimes google sheet.

Excel files live here: \\Box\Reports

Alert Susan, executive editor of each journal, Rob, Camille, and Production Editors to report availability.