# A tibble: 6 × 5
erisim_numarasi min_pacs_upload_time max_pacs_upload_time slide_count_pacs
<chr> <dttm> <dttm> <int>
1 0-00 2022-07-06 10:00:08 2025-07-18 07:35:28 3
2 0-01 2022-07-12 01:45:19 2025-04-19 17:11:52 2
3 0-02 2025-03-27 08:25:25 2025-03-27 08:25:25 1
4 0-03 2025-10-14 04:30:56 2025-10-14 04:30:56 1
5 0-04 2025-07-15 02:06:28 2025-07-15 02:06:28 1
6 0-06 2022-07-06 23:19:22 2022-07-06 23:19:22 1
# ℹ 1 more variable: scanner_model_pacs <chr>7 Prepare PACS Data
7.1 Load PACS Data
We load the PACS data using the load_pacs_data function. This function reads Excel files, cleans names, extracts case IDs, and parses dates.
7.2 Data Cleaning and Summary
We summarize the PACS data to find the upload time for each case. We define the case upload time as the maximum upload time of all slides in the case.
7.3 Save Processed Data
We save the processed PACS data in both Case Level and Slide Level formats.